Skip to content

Instantly share code, notes, and snippets.

JOINING DATA IN POSTGRESQL
Target is to join two or more database together in a single table
Innerjoin in SQL
Select p1.country, p1.continent,
Prime_minister, president
FROM prime_ministers AS p1
INNER JOIN presidents AS p2
ON p1.country = p2.country;
=====================================================================
Inner join
@sdg7onado
sdg7onado / nomatchinghistoryfix.md
Created March 26, 2022 04:55
How to Fix the Error: There isn’t anything to compare: main and development are entirely different commit histories.

How to Fix the Error: There isn’t anything to compare. main and development are entirely different commit histories.

Definitions

  1. 'main' out of date

  2. 'development' up to date

  3. 'issue' Unable to create PR from 'development' onto 'main' due to the following error: There isn’t anything to compare. main and development are entirely different commit histories.

Assumptions

  1. Fair understanding of Git

@aamiaa
aamiaa / CompleteDiscordQuest.md
Last active May 10, 2024 17:58
Complete Recent Discord Quest

Complete Recent Discord Quest

Note

This no longer works in browser!

Note

This no longer works if you're alone in vc! Somebody else has to join you!

How to use this script:

  1. Accept the quest under User Settings -> Gift Inventory

Instructor:

  • David Kearns, MBA, PMP, ACP
  • Working on VT Health Connect

Logistics

  • Start/Stop
  • Homework
    • 16 Page Scrum white paper
# 2024年5月9日 09点07分
# port: 7890 # HTTP(S) 代理服务器端口
# socks-port: 7891 # SOCKS5 代理端口
mixed-port: 10801 # HTTP(S) 和 SOCKS 代理混合端口
redir-port: 7892 # 透明代理端口,用于 Linux 和 MacOS
# Transparent proxy server port for Linux (TProxy TCP and TProxy UDP)
tproxy-port: 7893
nodes:
- id: webcam
custom:
source: https://huggingface.co/datasets/dora-rs/dora-idefics2/raw/main/operators/opencv_stream.py
outputs:
- image
- id: idefics2
operator:
python: https://huggingface.co/datasets/dora-rs/dora-idefics2/raw/main/operators/idefics2_op.py
inputs:
@scyto
scyto / proxmox-tb-net.md
Last active May 10, 2024 17:50
Thunderbolt Networking Setup

Thunderbolt Networking

this gist is part of this series

NOTE FOR THIS TO BE RELIABLE ON NODE RESTARTS YOU WILL NEED PROXMOX KERNEL 6.2.16-14-pve OR HIGER

This fixes issues i bugged with the thunderbolt / thunderbolt-net maintainers (i will take everyones thanks now, lol)

Install LLDP - this is great to see what nodes can see which.

  • install lldpctl with apt install lldpd
@prashant0085
prashant0085 / Mac-OS-Setup.md
Last active May 10, 2024 17:49
Mac OS setup for DevOps Engineer

Update Mac to latest version

Update your Mac to latest version of macOS.

Install Mac Xcode Command Line Tools

xcode-select --install
@ItzMarni
ItzMarni / Installing Vencord.md
Last active May 10, 2024 17:48
How to install custom Vencord plugins.

Installing unsupported/custom plugins (userplugins) - Last update: 10/05/2024

Note

Vencord is against TOS, although no one has been banned, I am not responsible for whatever happens to your account, you cant ask support either for custom plugins, you are all on your own.

Step 1

Make sure you have [Git] and [Node.JS] installed.

Step 2

@lzehrung
lzehrung / remove-node_modules-recurse.ps1
Created May 10, 2024 17:44
powershell remove node_modules recursively
Get-ChildItem -Path "." -Include "node_modules" -Recurse -Directory | Remove-Item -Recurse -Force